Table exists
Description
Table Exists checks whether a specified table is present in a database and returns true or false. Use this process entry to validate database structure before running dependent workflows — for example, confirming that a target table exists before a data load, or branching to a table creation step when the table is missing. This entry performs a single check; for repeated polling until a table appears, use the Evaluate Rows Number in a Table process entry instead.
Note: This process entry performs one check and then moves on. If you want to poll until the tables appear, use Evaluate rows number in a table process entry which has a polling interval parameter.
Configurations
| Field Name | Description |
|---|---|
| Process Entry name | Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name. |
| Connection | The name of the connection to connect to the database. |
| Schema name | The table's schema name. |
| Table name | The table name to check for existence. |